SectionOptions Object

The SectionOptions Object represents a section found in a report. A section is a part of a report area that can be formatted separately from other sections in the report. This object provides properties for retrieving information and setting options for a section in your report (that is, background color, new page after, etc.). A SectionOptions Object is obtained from the Options property of the Section Object.

Each report area is comprised of sections that can be formatted independently of each other using the SectionOptions object. These section options are combined with the options set by using the AreaOptions Object, to make up the final appearance of a section and an area of the report. The settings in the AreaOptions object will affect all sections within the area, while settings in the SectionOptions object will affect only the section they are set to.

If there is a conflict of settings between the AreaOptions object and the SectionOptions object, the object with an option set to TRUE will override the setting for the other object. For example, if the AreaOptions object has the KeepTogether property set to TRUE, all sections within the area will have KeepTogether applied, even if the SectionOptions object for a section has KeepTogether set to FALSE. If, however, the AreaOptions object has KeepTogether set to FALSE, but a section within that area has KeepTogether set to TRUE, that section will have the KeepTogether format option applied.

If an area has only a single section, all options will be combined between both the AreaOption object and the SectionOptions object. All TRUE settings set in either object will result in a TRUE setting for the entire area and section. While changing format options for areas and sections in reports, be sure to keep track of settings in both the AreaOptions and SectionOptions objects.

SectionOptions Object Properties

Property Description Read/Write

Application

Returns a reference to the Application Object, that this object is associated with.

Read only

BackColor

Returns/Sets CRColor (see table below) indicating OLE color. You can use CRColor values or declare your own colors by using OLE colors (that is, by using RGB function).

Read/Write


Constant Value


crAqua

16776960


crBlack

0


crBlue

16711680


crFuchsia

16711935


crGray

8421504


crGreen

32768


crLime

65280


crMaroon

128


crNoColor

-1


crOlive

32896


crPurple

8388736


crRed

255


crSilver

12632256


crTeal

8421376


crWhite

16777215


crYellow

65536

BackColor
Formula

Returns/Sets string specifying a formula for conditionally setting the background color of a section.

Read/Write

FreeForm
Placement

Returns/Sets Boolean value indicating if section has free form placement.

Read/Write

KeepTogether

Returns/Sets Boolean indicating if section keeps together (doesn't break) across pages

Read/Write

KeepTogether
Formula

Returns/Sets string specifying the formula for conditionally setting if a section should keep together (doesn't break) across pages.

Read/Write

NewPageAfter

Returns/Sets Boolean value indicating if there is a new page after the section is printed.

Read/Write

NewPageAfter
Formula

Returns/Sets string specifying the formula for conditionally setting the report to start a new page after this section is printed.

Read/Write

NewPageBefore

Returns/Sets Boolean value indicating if there is a new page before the section is printed.

Read/Write

NewPageBefore
Formula

Returns/Sets string specifying the formula for conditionally setting the report to start a new page before this section is printed.

Read/Write

Parent

Reference to the Parent object (Section Object).

Read only

PrintAtBottom
OfPage

Returns/Sets Boolean indicating if the section is printed at the bottom of the page.

Read/Write

PrintAtBottom
OfPageFormula

Returns/Sets string specifying formula for conditionally printing section at the bottom of the page.

Read/Write

Report

Reference to Report Object.

Read only

ResetPage
NumberAfter

Returns/Sets Boolean value indicating if the page number will be reset after the section is printed.

Read/Write

ResetPage
NumberAfter
Formula

Returns/Sets string specifying the formula for conditionally resetting the page number.

Read/Write

SuppressIfBlank

Returns/Sets Boolean value indicating if the section is suppressed when containing no data.

Read/Write

SuppressIf
BlankFormula

Returns/Sets string specifying the formula for conditionally suppressing a section when containing no data.

Read/Write

UnderlaySection

Returns/Sets Boolean value indicating if the section underlays the following sections.

Read/Write

UnderlaySection
Formula

Returns/Sets string specifying the formula for conditionally underlaying a section.

Read/Write

Visible

Returns/Sets Boolean value indicating whether a section is shown (visible).

Read/Write

VisibleFormula

Returns/Sets string specifying the formula for conditionally showing (making visible) a section.

Read/Write



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com